if exists(select name from sysobjects where name = 'sp_LoaiSanPhamDelete')
	drop proc sp_LoaiSanPhamDelete
go
/*
	Created by: Phuoc NH
	Created on: 22/01/2013 (dd/mm/yyyy)
	Description: delete loai san pham va san pham co loai_san_pham_id tuong ung
	--
	File:$sql-scripts/Proc.sp_LoaiSanPhamDelete.sql
*/

create proc sp_LoaiSanPhamDelete
@Loai_san_pham_id int
as
begin
	update tbl_Loai_san_pham set Status=0 where Loai_san_pham_id=@Loai_san_pham_id
	update tbl_San_pham set status=0 where loai_san_pham_id=@Loai_san_pham_id
end
go